﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using DataInfo;
using XBLib.Dal;
using XBLib.Dal.AdoDal;
using XBLib.BusinessObject;
using System.Data.Common;
using KenLib.BusinessObject;

namespace KenLib.Dal
{
    public class 面接詳細情報Dao : BaseAdoDao
    {
        #region //Thanh Dong
        public int frmJ_TraineeAppAssignCheck_Update(int ID, int 団体ID, int 団体ID_new, int 企業ID, int 企業ID_new, int 応募情報ID)
        { 
            DbParameter dbParam1 = _daoHelper.CreateParameter("@ID", ID, DbType.Int32);
            DbParameter dbParam2 = _daoHelper.CreateParameter("@団体ID", 団体ID, DbType.Int32);
            DbParameter dbParam3 = _daoHelper.CreateParameter("@団体ID_new", 団体ID_new, DbType.Int32);
            DbParameter dbParam4 = _daoHelper.CreateParameter("@企業ID", 企業ID, DbType.Int32);
            DbParameter dbParam5 = _daoHelper.CreateParameter("@企業ID_new", 企業ID_new, DbType.Int32);
            DbParameter dbParam6 = _daoHelper.CreateParameter("@応募情報ID", 応募情報ID, DbType.Int32);

            DbCommand dbcommand = _daoHelper.CreateCommand(CommandNameManager.sp_frmJ_TraineeAppAssignCheck_Update_Dong, CommandType.StoredProcedure, dbParam1, dbParam2, dbParam3, dbParam4, dbParam5, dbParam6);
            return _daoHelper.Execute(dbcommand);
        }

        public int frmJ_TraineeAppAssignCheck_Delete(int ID, int 団体ID, int 企業ID, int 応募情報ID)
        {
            DbParameter dbParam1 = _daoHelper.CreateParameter("@ID", ID, DbType.Int32);
            DbParameter dbParam2 = _daoHelper.CreateParameter("@団体ID", 団体ID, DbType.Int32);
            DbParameter dbParam3 = _daoHelper.CreateParameter("@企業ID", 企業ID, DbType.Int32);
            DbParameter dbParam4 = _daoHelper.CreateParameter("@応募情報ID", 応募情報ID, DbType.Int32);

            DbCommand dbcommand = _daoHelper.CreateCommand(CommandNameManager.sp_frmJ_TraineeAppAssignCheck_Delete_Dong, CommandType.StoredProcedure, dbParam1, dbParam2, dbParam3, dbParam4);
            return _daoHelper.Execute(dbcommand);
        }


        public int frmJ_TraineeListSelectCheck_Insert_面接詳細情報(面接詳細情報 _面接詳細情報)
        {
            DbParameter dbParam1 = _daoHelper.CreateParameter("@ID", _面接詳細情報.ID, DbType.Int32);
            DbParameter dbParam2 = _daoHelper.CreateParameter("@団体ID", _面接詳細情報.団体ID, DbType.Int32);
            DbParameter dbParam3 = _daoHelper.CreateParameter("@企業ID", _面接詳細情報.企業ID, DbType.Int32);
            DbParameter dbParam4 = _daoHelper.CreateParameter("@応募情報ID", _面接詳細情報.応募情報ID, DbType.Int32);
            DbParameter dbParam5 = _daoHelper.CreateParameter("@面接番号", _面接詳細情報.面接番号, DbType.String);

            DbCommand dbcommand = _daoHelper.CreateCommand(CommandNameManager.sp_frmJ_TraineeListSelectCheck_Insert_面接詳細情報_Dong, CommandType.StoredProcedure,dbParam1, dbParam2, dbParam3, dbParam4, dbParam5);
            return _daoHelper.Execute(dbcommand);
        }

        public int frmJ_CandidateSendEmail_Delete_面接詳細情報(int ID)
        {
            DbParameter dbparam = _daoHelper.CreateParameter("@ID", ID, DbType.Int32);
            DbCommand dbcommand = _daoHelper.CreateCommand(CommandNameManager.sp_frmJ_CandidateSendEmail_Delete_面接詳細情報_Dong, CommandType.StoredProcedure, dbparam);
            return _daoHelper.Execute(dbcommand);
        }
        #endregion
    }
}
